USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[WeaponKillsTop25Select]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.WeaponKillsTop25Select
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 09/24/08
-- Description:	Weapon Kills Top 25 Select
-- =============================================
CREATE PROCEDURE WeaponKillsTop25Select

AS

BEGIN

	SELECT TOP 25 Attacker_playerId AS [PlayerId], 
			Count(Attacker_playerId) AS [Kills],
			0 AS [Deaths],
			0.0 AS [KillDeathRatio]
	FROM Kills
	WHERE Attacker_classId = 2
	GROUP BY Attacker_playerId
	ORDER BY [Kills] DESC


select * from kills where attacker_playerid = 'STEAM_0:0:5026980'
and attacker_classid = 2

END
GO


